<?php
require 'Model.php';
class UserModel extends Model{
	function __Construct(){
		parent::__Construct();
		$this->mod='users';
	}
	function getList()
	{
		$sql = "select * from {$this->mod}";
		$data = $this->conn->query($sql);
		return $data;
	}
	function add($data)
	{
		if(!empty($_FILES["pic"]["name"])){
			$pic = $this->uploadfile('pic','./upload/',array('jpg','gif','png'));
		}
		else{
			$pic='';
		}
		$user = array(
			'uname' => trim($data['username']),  
			'password' => $data['password'],
			'gender' => $data['gender'],
			'birthdate' => $data['birthdate'],
			'hobby' => implode($data['hobby'], ','),
			'degree' => $data['degree'],
			'intro' => $data['intro'],
			'pic'=>$pic
			);
		$keys = implode(',',array_keys($user));
		$values = implode("','", array_values($user));
		$sql="insert into users ({$keys}) VALUES ('{$values}')";
			  //执行SQL语句
		$result = $this->conn->query($sql);
		return $result;
	}
	function getUserByID($id){
		$sql = "select * from users where uid=".$id;
		$result = $this->conn->query($sql);
		return $result;
	}
	function update($data)
	{
		$user = array(
			'uname' => trim($data['uname']),  
					//'password' => $data['password'],
			'gender' => $data['gender'],
			'birthdate' => $data['birthdate'],
			'hobby' => implode($data['hobby'], ','),
			'degree' => $data['degree'],
			'intro' => $data['intro'],
			);
		if(!empty($_FILES["pic"]["name"])){
			$pic = $this->uploadfile('pic','./upload/',array('jpg','gif','png'));
			$user['pic'] = $pic;
		}
		
		
		$sets = '';
		foreach ($user as $key=>$val){
			$sets.=$key."='".$val."',";
		}
			    $sets=rtrim($sets,','); //去掉SQL里的最后一个逗号
			    
			    $sql="UPDATE users SET {$sets} where uid=".$data['id'];
			  //执行SQL语句
			    $result = $this->conn->query($sql);
			    return $result;		    
			}
			function delete($id)
			{
				$sql = "delete from users where uid=".$id;
				$result = $this->conn->query($sql);
				return $result;
			}




		}
		?>